﻿CREATE TABLE [dbo].[Criterion] (
    [Id]            UNIQUEIDENTIFIER NOT NULL,
    [AgeMin]        INT              NULL,
    [AgeMax]        INT              NULL,
    [HeightMin]     INT              NULL,
    [HeightMax]     INT              NULL,
    [Marry]         NVARCHAR (20)    NULL,
    [Education]     NVARCHAR (20)    NULL,
    [EducationOver] BIT              NOT NULL,
    [Photograph]    BIT              NOT NULL,
    [Grade]         BIT              NOT NULL,
    [Province]      NVARCHAR (20)    NULL,
    [City]          NVARCHAR (20)    NULL,
    [Comment]       NVARCHAR (500)   NULL,
    CONSTRAINT [PK_Criteria] PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK_Criterion_Member] FOREIGN KEY ([Id]) REFERENCES [dbo].[Member] ([Id])
);



